Dataset statistics
| Number of variables | 31 |
|---|---|
| Number of observations | 450000 |
| Missing cells | 1946668 |
| Missing cells (%) | 14.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 106.4 MiB |
| Average record size in memory | 248.0 B |
Variable types
| DateTime | 7 |
|---|---|
| Numeric | 17 |
| Categorical | 7 |
first_mile_distance is highly correlated with total_dist | High correlation |
last_mile_distance is highly correlated with total_dist | High correlation |
alloted_orders is highly correlated with delivered_orders and 2 other fields | High correlation |
delivered_orders is highly correlated with alloted_orders and 1 other fields | High correlation |
undelivered_orders is highly correlated with alloted_orders and 1 other fields | High correlation |
lifetime_order_count is highly correlated with alloted_orders and 1 other fields | High correlation |
total_dist is highly correlated with first_mile_distance and 1 other fields | High correlation |
order_time_hour is highly correlated with accept_time_hour and 1 other fields | High correlation |
accept_time_hour is highly correlated with order_time_hour and 1 other fields | High correlation |
delivered_fraction is highly correlated with undelivered_orders | High correlation |
cancelled_hour is highly correlated with order_time_hour and 1 other fields | High correlation |
first_mile_distance is highly correlated with total_dist | High correlation |
last_mile_distance is highly correlated with total_dist | High correlation |
alloted_orders is highly correlated with delivered_orders | High correlation |
delivered_orders is highly correlated with alloted_orders | High correlation |
reassigned_order is highly correlated with accept_order_diff | High correlation |
total_dist is highly correlated with first_mile_distance and 1 other fields | High correlation |
order_time_hour is highly correlated with accept_time_hour and 1 other fields | High correlation |
accept_time_hour is highly correlated with order_time_hour and 1 other fields | High correlation |
accept_order_diff is highly correlated with reassigned_order | High correlation |
cancelled_hour is highly correlated with order_time_hour and 1 other fields | High correlation |
last_mile_distance is highly correlated with total_dist | High correlation |
alloted_orders is highly correlated with delivered_orders | High correlation |
delivered_orders is highly correlated with alloted_orders | High correlation |
undelivered_orders is highly correlated with delivered_fraction | High correlation |
total_dist is highly correlated with last_mile_distance | High correlation |
order_time_hour is highly correlated with accept_time_hour and 1 other fields | High correlation |
accept_time_hour is highly correlated with order_time_hour and 1 other fields | High correlation |
delivered_fraction is highly correlated with undelivered_orders | High correlation |
cancelled_hour is highly correlated with order_time_hour and 1 other fields | High correlation |
reassignment_method is highly correlated with reassigned_order | High correlation |
reassigned_order is highly correlated with reassignment_method and 1 other fields | High correlation |
reassignment_reason is highly correlated with reassigned_order | High correlation |
order_id is highly correlated with order_date and 2 other fields | High correlation |
order_date is highly correlated with order_id and 2 other fields | High correlation |
first_mile_distance is highly correlated with total_dist | High correlation |
last_mile_distance is highly correlated with total_dist | High correlation |
alloted_orders is highly correlated with delivered_orders and 1 other fields | High correlation |
delivered_orders is highly correlated with alloted_orders and 1 other fields | High correlation |
undelivered_orders is highly correlated with alloted_orders and 1 other fields | High correlation |
session_time is highly correlated with order_time_hour and 1 other fields | High correlation |
total_dist is highly correlated with first_mile_distance and 1 other fields | High correlation |
weekday is highly correlated with order_id and 2 other fields | High correlation |
order_time_hour is highly correlated with session_time and 2 other fields | High correlation |
accept_time_hour is highly correlated with session_time and 2 other fields | High correlation |
weekday_num is highly correlated with order_id and 2 other fields | High correlation |
cancelled_hour is highly correlated with order_time_hour and 1 other fields | High correlation |
delivered_time has 5218 (1.2%) missing values | Missing |
reassignment_method has 436256 (96.9%) missing values | Missing |
reassignment_reason has 436247 (96.9%) missing values | Missing |
cancelled_time has 444782 (98.8%) missing values | Missing |
delivered_fraction has 16948 (3.8%) missing values | Missing |
call_total has 159543 (35.5%) missing values | Missing |
cancelled_hour has 444782 (98.8%) missing values | Missing |
alloted_orders has 16948 (3.8%) zeros | Zeros |
delivered_orders has 17341 (3.9%) zeros | Zeros |
undelivered_orders has 250027 (55.6%) zeros | Zeros |
weekday_num has 37833 (8.4%) zeros | Zeros |
Reproduction
| Analysis started | 2022-02-16 15:55:00.593392 |
|---|---|
| Analysis finished | 2022-02-16 15:56:58.380001 |
| Duration | 1 minute and 57.79 seconds |
| Software version | pandas-profiling v3.1.0 |
| Download configuration | config.json |
order_time
Date
| Distinct | 252868 |
|---|---|
| Distinct (%) | 56.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.4 MiB |
| Minimum | 2021-01-26 02:21:35 |
|---|---|
| Maximum | 2021-02-06 10:03:24 |
| Distinct | 449999 |
|---|---|
| Distinct (%) | > 99.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 369143.0808 |
| Minimum | 118350 |
|---|---|
| Maximum | 594842 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.4 MiB |
Quantile statistics
| Minimum | 118350 |
|---|---|
| 5-th percentile | 167343.95 |
| Q1 | 257342.75 |
| median | 369842.5 |
| Q3 | 482342.25 |
| 95-th percentile | 572342.05 |
| Maximum | 594842 |
| Range | 476492 |
| Interquartile range (IQR) | 224999.5 |
Descriptive statistics
| Standard deviation | 131146.9064 |
|---|---|
| Coefficient of variation (CV) | 0.355273912 |
| Kurtosis | -1.149146297 |
| Mean | 369143.0808 |
| Median Absolute Deviation (MAD) | 112500 |
| Skewness | -0.03426737717 |
| Sum | 1.661143863 × 1011 |
| Variance | 1.719951106 × 1010 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 181402 | 2 | < 0.1% |
| 556753 | 1 | < 0.1% |
| 306422 | 1 | < 0.1% |
| 306433 | 1 | < 0.1% |
| 306430 | 1 | < 0.1% |
| 306429 | 1 | < 0.1% |
| 306428 | 1 | < 0.1% |
| 306431 | 1 | < 0.1% |
| 306432 | 1 | < 0.1% |
| 306427 | 1 | < 0.1% |
| Other values (449989) | 449989 |
| Value | Count | Frequency (%) |
| 118350 | 1 | |
| 118351 | 1 | |
| 118352 | 1 | |
| 118353 | 1 | |
| 118354 | 1 | |
| 118355 | 1 | |
| 118356 | 1 | |
| 118357 | 1 | |
| 118358 | 1 | |
| 118359 | 1 |
| Value | Count | Frequency (%) |
| 594842 | 1 | |
| 594841 | 1 | |
| 594840 | 1 | |
| 594839 | 1 | |
| 594838 | 1 | |
| 594837 | 1 | |
| 594836 | 1 | |
| 594835 | 1 | |
| 594834 | 1 | |
| 594833 | 1 |
| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.4 MiB |
| Minimum | 2021-01-26 00:00:00 |
|---|---|
| Maximum | 2021-02-06 00:00:00 |
allot_time
Date
| Distinct | 246871 |
|---|---|
| Distinct (%) | 54.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.4 MiB |
| Minimum | 2021-01-26 02:21:59 |
|---|---|
| Maximum | 2021-02-06 10:52:57 |
accept_time
Date
| Distinct | 254201 |
|---|---|
| Distinct (%) | 56.5% |
| Missing | 157 |
| Missing (%) | < 0.1% |
| Memory size | 3.4 MiB |
| Minimum | 2021-01-26 02:22:08 |
|---|---|
| Maximum | 2021-02-06 10:53:03 |
pickup_time
Date
| Distinct | 257117 |
|---|---|
| Distinct (%) | 57.4% |
| Missing | 2421 |
| Missing (%) | 0.5% |
| Memory size | 3.4 MiB |
| Minimum | 2021-01-26 02:32:51 |
|---|---|
| Maximum | 2021-02-08 07:52:34 |
| Distinct | 257067 |
|---|---|
| Distinct (%) | 57.8% |
| Missing | 5218 |
| Missing (%) | 1.2% |
| Memory size | 3.4 MiB |
| Minimum | 2021-01-26 02:49:47 |
|---|---|
| Maximum | 2021-02-08 16:19:04 |
rider_id
Real number (ℝ≥0)
| Distinct | 19537 |
|---|---|
| Distinct (%) | 4.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7763.244016 |
| Minimum | 0 |
|---|---|
| Maximum | 21566 |
| Zeros | 7 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 519 |
| Q1 | 2805 |
| median | 6754 |
| Q3 | 11965 |
| 95-th percentile | 18050 |
| Maximum | 21566 |
| Range | 21566 |
| Interquartile range (IQR) | 9160 |
Descriptive statistics
| Standard deviation | 5592.880135 |
|---|---|
| Coefficient of variation (CV) | 0.7204308049 |
| Kurtosis | -0.8427443266 |
| Mean | 7763.244016 |
| Median Absolute Deviation (MAD) | 4436 |
| Skewness | 0.4790871039 |
| Sum | 3493459807 |
| Variance | 31280308.2 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 237 | 228 | 0.1% |
| 190 | 213 | < 0.1% |
| 11998 | 209 | < 0.1% |
| 170 | 203 | < 0.1% |
| 853 | 200 | < 0.1% |
| 747 | 199 | < 0.1% |
| 2280 | 195 | < 0.1% |
| 4921 | 194 | < 0.1% |
| 12709 | 191 | < 0.1% |
| 453 | 190 | < 0.1% |
| Other values (19527) | 447978 |
| Value | Count | Frequency (%) |
| 0 | 7 | < 0.1% |
| 1 | 16 | < 0.1% |
| 2 | 28 | < 0.1% |
| 4 | 3 | < 0.1% |
| 5 | 19 | < 0.1% |
| 6 | 15 | < 0.1% |
| 9 | 29 | < 0.1% |
| 10 | 97 | |
| 11 | 25 | < 0.1% |
| 12 | 24 | < 0.1% |
| Value | Count | Frequency (%) |
| 21566 | 1 | |
| 21565 | 1 | |
| 21564 | 1 | |
| 21563 | 1 | |
| 21562 | 1 | |
| 21561 | 1 | |
| 21560 | 2 | |
| 21559 | 2 | |
| 21558 | 2 | |
| 21557 | 1 |
| Distinct | 93743 |
|---|---|
| Distinct (%) | 20.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.229888977 |
| Minimum | 0.0001342587859 |
|---|---|
| Maximum | 42.0381 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.4 MiB |
Quantile statistics
| Minimum | 0.0001342587859 |
|---|---|
| 5-th percentile | 0.05458151785 |
| Q1 | 0.539575 |
| median | 1.1387 |
| Q3 | 1.853 |
| 95-th percentile | 2.7079 |
| Maximum | 42.0381 |
| Range | 42.03796574 |
| Interquartile range (IQR) | 1.313425 |
Descriptive statistics
| Standard deviation | 0.8461826096 |
|---|---|
| Coefficient of variation (CV) | 0.688015443 |
| Kurtosis | 12.36678626 |
| Mean | 1.229888977 |
| Median Absolute Deviation (MAD) | 0.6482 |
| Skewness | 0.7588916893 |
| Sum | 553450.0398 |
| Variance | 0.7160250088 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0.7153 | 39 | < 0.1% |
| 0.7404 | 39 | < 0.1% |
| 0.6965 | 36 | < 0.1% |
| 0.6959 | 36 | < 0.1% |
| 0.7241 | 34 | < 0.1% |
| 0.6578 | 34 | < 0.1% |
| 0.6883 | 34 | < 0.1% |
| 1.0009 | 34 | < 0.1% |
| 1.5356 | 34 | < 0.1% |
| 0.6174 | 34 | < 0.1% |
| Other values (93733) | 449646 |
| Value | Count | Frequency (%) |
| 0.0001342587859 | 2 | < 0.1% |
| 0.0002122817797 | 1 | < 0.1% |
| 0.0002848058939 | 1 | < 0.1% |
| 0.000328865519 | 1 | < 0.1% |
| 0.0003797411919 | 2 | < 0.1% |
| 0.0004027763578 | 5 | |
| 0.00041381337 | 1 | < 0.1% |
| 0.0004452860177 | 2 | < 0.1% |
| 0.0004552936947 | 3 | |
| 0.0004650860772 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 42.0381 | 1 | |
| 17.3442 | 1 | |
| 11.6741 | 1 | |
| 11.3649 | 1 | |
| 10.7525 | 1 | |
| 10.6994 | 1 | |
| 10.5839 | 1 | |
| 10.0546 | 1 | |
| 9.6695 | 1 | |
| 9.6079 | 1 |
last_mile_distance
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATION| Distinct | 1331 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.968872711 |
| Minimum | 0 |
|---|---|
| Maximum | 22.41 |
| Zeros | 94 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.5 |
| Q1 | 1.47 |
| median | 2.67 |
| Q3 | 4.22 |
| 95-th percentile | 6.22 |
| Maximum | 22.41 |
| Range | 22.41 |
| Interquartile range (IQR) | 2.75 |
Descriptive statistics
| Standard deviation | 1.884123753 |
|---|---|
| Coefficient of variation (CV) | 0.6346259797 |
| Kurtosis | 0.8795462088 |
| Mean | 2.968872711 |
| Median Absolute Deviation (MAD) | 1.33 |
| Skewness | 0.8267706027 |
| Sum | 1335992.72 |
| Variance | 3.549922316 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1.58 | 1143 | 0.3% |
| 1.5 | 1121 | 0.2% |
| 1.97 | 1119 | 0.2% |
| 1.45 | 1111 | 0.2% |
| 1.63 | 1110 | 0.2% |
| 1.46 | 1109 | 0.2% |
| 1.54 | 1107 | 0.2% |
| 1.32 | 1105 | 0.2% |
| 1.76 | 1104 | 0.2% |
| 1.67 | 1104 | 0.2% |
| Other values (1321) | 438867 |
| Value | Count | Frequency (%) |
| 0 | 94 | < 0.1% |
| 0.01 | 170 | < 0.1% |
| 0.02 | 210 | |
| 0.03 | 193 | |
| 0.04 | 237 | |
| 0.05 | 253 | |
| 0.06 | 291 | |
| 0.07 | 353 | |
| 0.08 | 415 | |
| 0.09 | 482 |
| Value | Count | Frequency (%) |
| 22.41 | 1 | |
| 22.26 | 1 | |
| 21.27 | 1 | |
| 21.21 | 1 | |
| 21.2 | 1 | |
| 21.12 | 1 | |
| 19.81 | 1 | |
| 18.13 | 1 | |
| 17.27 | 1 | |
| 16.85 | 1 |
alloted_orders
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONZEROS| Distinct | 511 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 100.6806533 |
| Minimum | 0 |
|---|---|
| Maximum | 567 |
| Zeros | 16948 |
| Zeros (%) | 3.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 31 |
| median | 77 |
| Q3 | 144 |
| 95-th percentile | 286 |
| Maximum | 567 |
| Range | 567 |
| Interquartile range (IQR) | 113 |
Descriptive statistics
| Standard deviation | 90.63736221 |
|---|---|
| Coefficient of variation (CV) | 0.9002460673 |
| Kurtosis | 2.094703755 |
| Mean | 100.6806533 |
| Median Absolute Deviation (MAD) | 53 |
| Skewness | 1.382605843 |
| Sum | 45306294 |
| Variance | 8215.131429 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 16948 | 3.8% |
| 6 | 3764 | 0.8% |
| 5 | 3717 | 0.8% |
| 4 | 3648 | 0.8% |
| 2 | 3589 | 0.8% |
| 7 | 3586 | 0.8% |
| 3 | 3513 | 0.8% |
| 10 | 3424 | 0.8% |
| 8 | 3309 | 0.7% |
| 9 | 3168 | 0.7% |
| Other values (501) | 401334 |
| Value | Count | Frequency (%) |
| 0 | 16948 | |
| 1 | 2991 | 0.7% |
| 2 | 3589 | 0.8% |
| 3 | 3513 | 0.8% |
| 4 | 3648 | 0.8% |
| 5 | 3717 | 0.8% |
| 6 | 3764 | 0.8% |
| 7 | 3586 | 0.8% |
| 8 | 3309 | 0.7% |
| 9 | 3168 | 0.7% |
| Value | Count | Frequency (%) |
| 567 | 12 | |
| 565 | 18 | |
| 563 | 17 | |
| 561 | 18 | |
| 558 | 9 | < 0.1% |
| 555 | 25 | |
| 553 | 21 | |
| 545 | 28 | |
| 540 | 21 | |
| 536 | 20 |
delivered_orders
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONZEROS| Distinct | 505 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 99.94466 |
| Minimum | 0 |
|---|---|
| Maximum | 562 |
| Zeros | 17341 |
| Zeros (%) | 3.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 31 |
| median | 77 |
| Q3 | 143 |
| 95-th percentile | 284 |
| Maximum | 562 |
| Range | 562 |
| Interquartile range (IQR) | 112 |
Descriptive statistics
| Standard deviation | 90.14421802 |
|---|---|
| Coefficient of variation (CV) | 0.9019413145 |
| Kurtosis | 2.113953265 |
| Mean | 99.94466 |
| Median Absolute Deviation (MAD) | 52 |
| Skewness | 1.387814359 |
| Sum | 44975097 |
| Variance | 8125.980042 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 17341 | 3.9% |
| 6 | 3798 | 0.8% |
| 4 | 3698 | 0.8% |
| 5 | 3697 | 0.8% |
| 7 | 3645 | 0.8% |
| 3 | 3528 | 0.8% |
| 2 | 3525 | 0.8% |
| 10 | 3403 | 0.8% |
| 8 | 3322 | 0.7% |
| 13 | 3228 | 0.7% |
| Other values (495) | 400815 |
| Value | Count | Frequency (%) |
| 0 | 17341 | |
| 1 | 2949 | 0.7% |
| 2 | 3525 | 0.8% |
| 3 | 3528 | 0.8% |
| 4 | 3698 | 0.8% |
| 5 | 3697 | 0.8% |
| 6 | 3798 | 0.8% |
| 7 | 3645 | 0.8% |
| 8 | 3322 | 0.7% |
| 9 | 3180 | 0.7% |
| Value | Count | Frequency (%) |
| 562 | 12 | |
| 560 | 18 | |
| 559 | 17 | |
| 557 | 18 | |
| 553 | 9 | < 0.1% |
| 550 | 25 | |
| 548 | 21 | |
| 540 | 28 | |
| 535 | 21 | |
| 531 | 20 |
cancelled
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.4 MiB |
| 0 | |
|---|---|
| 1 | 5218 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 444782 | |
| 1 | 5218 | 1.2% |
Length
Pie chart
| Value | Count | Frequency (%) |
| 0 | 444782 | |
| 1 | 5218 | 1.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 10 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.7347177778 |
| Minimum | 0 |
|---|---|
| Maximum | 9 |
| Zeros | 250027 |
| Zeros (%) | 55.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 1 |
| 95-th percentile | 3 |
| Maximum | 9 |
| Range | 9 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 1.056017171 |
|---|---|
| Coefficient of variation (CV) | 1.437309948 |
| Kurtosis | 4.89193206 |
| Mean | 0.7347177778 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.89921989 |
| Sum | 330623 |
| Variance | 1.115172265 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 250027 | |
| 1 | 118103 | |
| 2 | 50582 | 11.2% |
| 3 | 20011 | 4.4% |
| 4 | 7733 | 1.7% |
| 5 | 1851 | 0.4% |
| 6 | 932 | 0.2% |
| 7 | 600 | 0.1% |
| 8 | 105 | < 0.1% |
| 9 | 56 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 250027 | |
| 1 | 118103 | |
| 2 | 50582 | 11.2% |
| 3 | 20011 | 4.4% |
| 4 | 7733 | 1.7% |
| 5 | 1851 | 0.4% |
| 6 | 932 | 0.2% |
| 7 | 600 | 0.1% |
| 8 | 105 | < 0.1% |
| 9 | 56 | < 0.1% |
| Value | Count | Frequency (%) |
| 9 | 56 | < 0.1% |
| 8 | 105 | < 0.1% |
| 7 | 600 | 0.1% |
| 6 | 932 | 0.2% |
| 5 | 1851 | 0.4% |
| 4 | 7733 | 1.7% |
| 3 | 20011 | 4.4% |
| 2 | 50582 | 11.2% |
| 1 | 118103 | |
| 0 | 250027 |
| Distinct | 2887 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 853.5401244 |
| Minimum | 0 |
|---|---|
| Maximum | 30469 |
| Zeros | 58 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 50 |
| Q1 | 165 |
| median | 396 |
| Q3 | 948 |
| 95-th percentile | 3013 |
| Maximum | 30469 |
| Range | 30469 |
| Interquartile range (IQR) | 783 |
Descriptive statistics
| Standard deviation | 1502.9162 |
|---|---|
| Coefficient of variation (CV) | 1.760803221 |
| Kurtosis | 77.97124105 |
| Mean | 853.5401244 |
| Median Absolute Deviation (MAD) | 287 |
| Skewness | 6.75716413 |
| Sum | 384093056 |
| Variance | 2258757.105 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 50 | 1609 | 0.4% |
| 51 | 1230 | 0.3% |
| 290 | 1201 | 0.3% |
| 130 | 1170 | 0.3% |
| 166 | 1162 | 0.3% |
| 228 | 1161 | 0.3% |
| 99 | 1104 | 0.2% |
| 84 | 1091 | 0.2% |
| 57 | 1086 | 0.2% |
| 106 | 1084 | 0.2% |
| Other values (2877) | 438102 |
| Value | Count | Frequency (%) |
| 0 | 58 | < 0.1% |
| 1 | 172 | |
| 2 | 232 | |
| 3 | 293 | |
| 4 | 280 | |
| 5 | 381 | |
| 6 | 344 | |
| 7 | 428 | |
| 8 | 369 | |
| 9 | 375 |
| Value | Count | Frequency (%) |
| 30469 | 50 | |
| 27972 | 55 | |
| 26810 | 26 | < 0.1% |
| 24933 | 4 | < 0.1% |
| 24022 | 80 | |
| 23626 | 33 | |
| 22581 | 34 | |
| 22033 | 27 | < 0.1% |
| 21995 | 10 | < 0.1% |
| 21938 | 7 | < 0.1% |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 436256 |
| Missing (%) | 96.9% |
| Memory size | 3.4 MiB |
| auto | |
|---|---|
| manual | 361 |
Length
| Max length | 6 |
|---|---|
| Median length | 4 |
| Mean length | 4.052532014 |
| Min length | 4 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | auto |
|---|---|
| 2nd row | auto |
| 3rd row | auto |
| 4th row | auto |
| 5th row | auto |
Common Values
| Value | Count | Frequency (%) |
| auto | 13383 | 3.0% |
| manual | 361 | 0.1% |
| (Missing) | 436256 |
Length
Pie chart
| Value | Count | Frequency (%) |
| auto | 13383 | |
| manual | 361 | 2.6% |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 436247 |
| Missing (%) | 96.9% |
| Memory size | 3.4 MiB |
| Auto Reassignment basis Inaction. coreengine.tasks.repush_order_to_aa_bucket | |
|---|---|
| Reassignment Request from SE portal. | |
| Reassign |
Length
| Max length | 76 |
|---|---|
| Median length | 76 |
| Mean length | 54.44921108 |
| Min length | 8 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Reassignment Request from SE portal. |
|---|---|
| 2nd row | Reassignment Request from SE portal. |
| 3rd row | Auto Reassignment basis Inaction. coreengine.tasks.repush_order_to_aa_bucket |
| 4th row | Auto Reassignment basis Inaction. coreengine.tasks.repush_order_to_aa_bucket |
| 5th row | Reassignment Request from SE portal. |
Common Values
| Value | Count | Frequency (%) |
| Auto Reassignment basis Inaction. coreengine.tasks.repush_order_to_aa_bucket | 7212 | 1.6% |
| Reassignment Request from SE portal. | 5300 | 1.2% |
| Reassign | 1241 | 0.3% |
| (Missing) | 436247 |
Length
Pie chart
| Value | Count | Frequency (%) |
| reassignment | 12512 | |
| auto | 7212 | |
| basis | 7212 | |
| inaction | 7212 | |
| coreengine.tasks.repush_order_to_aa_bucket | 7212 | |
| request | 5300 | |
| from | 5300 | |
| se | 5300 | |
| portal | 5300 | |
| reassign | 1241 | 1.9% |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.4 MiB |
| 0.0 | |
|---|---|
| 1.0 | 13753 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0.0 |
|---|---|
| 2nd row | 0.0 |
| 3rd row | 0.0 |
| 4th row | 0.0 |
| 5th row | 0.0 |
Common Values
| Value | Count | Frequency (%) |
| 0.0 | 436247 | |
| 1.0 | 13753 | 3.1% |
Length
Pie chart
| Value | Count | Frequency (%) |
| 0.0 | 436247 | |
| 1.0 | 13753 | 3.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 65872 |
|---|---|
| Distinct (%) | 14.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 220.1078929 |
| Minimum | 0 |
|---|---|
| Maximum | 1298.966667 |
| Zeros | 16 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 9.949166667 |
| Q1 | 84.85 |
| median | 175.55 |
| Q3 | 314.6875 |
| 95-th percentile | 580.5008333 |
| Maximum | 1298.966667 |
| Range | 1298.966667 |
| Interquartile range (IQR) | 229.8375 |
Descriptive statistics
| Standard deviation | 176.0372292 |
|---|---|
| Coefficient of variation (CV) | 0.7997769952 |
| Kurtosis | 0.3322033297 |
| Mean | 220.1078929 |
| Median Absolute Deviation (MAD) | 103.2333333 |
| Skewness | 0.9955830323 |
| Sum | 99048551.78 |
| Variance | 30989.10605 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 175.55 | 3697 | 0.8% |
| 0.06666666667 | 155 | < 0.1% |
| 0.03333333333 | 144 | < 0.1% |
| 0.1166666667 | 136 | < 0.1% |
| 0.15 | 132 | < 0.1% |
| 0.05 | 129 | < 0.1% |
| 0.08333333333 | 124 | < 0.1% |
| 240 | 120 | < 0.1% |
| 0.1 | 118 | < 0.1% |
| 0.1333333333 | 117 | < 0.1% |
| Other values (65862) | 445128 |
| Value | Count | Frequency (%) |
| 0 | 16 | < 0.1% |
| 0.01666666667 | 115 | |
| 0.03333333333 | 144 | |
| 0.05 | 129 | |
| 0.06666666667 | 155 | |
| 0.08333333333 | 124 | |
| 0.1 | 118 | |
| 0.1166666667 | 136 | |
| 0.1333333333 | 117 | |
| 0.15 | 132 |
| Value | Count | Frequency (%) |
| 1298.966667 | 1 | |
| 1294.433333 | 1 | |
| 1250.333333 | 1 | |
| 1183.566667 | 1 | |
| 1141.533333 | 1 | |
| 1096.833333 | 1 | |
| 1076.85 | 1 | |
| 1057.483333 | 1 | |
| 1043.866667 | 1 | |
| 1038.216667 | 1 |
| Distinct | 5176 |
|---|---|
| Distinct (%) | 99.2% |
| Missing | 444782 |
| Missing (%) | 98.8% |
| Memory size | 3.4 MiB |
| Minimum | 2021-01-26 04:08:50 |
|---|---|
| Maximum | 2021-02-07 10:04:25 |
| Distinct | 187961 |
|---|---|
| Distinct (%) | 41.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.198761688 |
| Minimum | 0.003223609088 |
|---|---|
| Maximum | 45.8281 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.4 MiB |
Quantile statistics
| Minimum | 0.003223609088 |
|---|---|
| 5-th percentile | 1.143691697 |
| Q1 | 2.5178 |
| median | 3.9779 |
| Q3 | 5.6016 |
| 95-th percentile | 7.9983 |
| Maximum | 45.8281 |
| Range | 45.82487639 |
| Interquartile range (IQR) | 3.0838 |
Descriptive statistics
| Standard deviation | 2.163998339 |
|---|---|
| Coefficient of variation (CV) | 0.5153896552 |
| Kurtosis | 0.8577599078 |
| Mean | 4.198761688 |
| Median Absolute Deviation (MAD) | 1.531 |
| Skewness | 0.669952122 |
| Sum | 1889442.76 |
| Variance | 4.68288881 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2.2972 | 20 | < 0.1% |
| 4.7797 | 18 | < 0.1% |
| 3.6433 | 17 | < 0.1% |
| 3.8197 | 16 | < 0.1% |
| 3.1253 | 16 | < 0.1% |
| 3.1886 | 16 | < 0.1% |
| 3.7092 | 16 | < 0.1% |
| 4.0858 | 16 | < 0.1% |
| 3.2096 | 16 | < 0.1% |
| 4.2522 | 15 | < 0.1% |
| Other values (187951) | 449834 |
| Value | Count | Frequency (%) |
| 0.003223609088 | 1 | |
| 0.008991831214 | 1 | |
| 0.0121958598 | 1 | |
| 0.01771045909 | 1 | |
| 0.01779741926 | 1 | |
| 0.0209460918 | 1 | |
| 0.02390761613 | 1 | |
| 0.02566731646 | 1 | |
| 0.02574129946 | 1 | |
| 0.02729673192 | 1 |
| Value | Count | Frequency (%) |
| 45.8281 | 1 | |
| 23.4694 | 1 | |
| 23.1514 | 1 | |
| 23.1353 | 1 | |
| 22.9468 | 1 | |
| 22.9131 | 1 | |
| 21.8706 | 1 | |
| 21.5442 | 1 | |
| 21.5325 | 1 | |
| 19.0825 | 1 |
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.4 MiB |
| Friday | |
|---|---|
| Thursday | |
| Wednesday | |
| Tuesday | |
| Saturday | |
| Other values (2) |
Length
| Max length | 9 |
|---|---|
| Median length | 7 |
| Mean length | 7.289393333 |
| Min length | 6 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Tuesday |
|---|---|
| 2nd row | Tuesday |
| 3rd row | Tuesday |
| 4th row | Tuesday |
| 5th row | Tuesday |
Common Values
| Value | Count | Frequency (%) |
| Friday | 83548 | |
| Thursday | 80468 | |
| Wednesday | 80462 | |
| Tuesday | 78965 | |
| Saturday | 49470 | |
| Sunday | 39254 | |
| Monday | 37833 |
Length
Pie chart
| Value | Count | Frequency (%) |
| friday | 83548 | |
| thursday | 80468 | |
| wednesday | 80462 | |
| tuesday | 78965 | |
| saturday | 49470 | |
| sunday | 39254 | |
| monday | 37833 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
order_time_hour
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATION| Distinct | 22 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 12.7238 |
| Minimum | 0 |
|---|---|
| Maximum | 21 |
| Zeros | 2 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 6 |
| Q1 | 9 |
| median | 14 |
| Q3 | 16 |
| 95-th percentile | 17 |
| Maximum | 21 |
| Range | 21 |
| Interquartile range (IQR) | 7 |
Descriptive statistics
| Standard deviation | 3.619623125 |
|---|---|
| Coefficient of variation (CV) | 0.2844765813 |
| Kurtosis | -0.9800672739 |
| Mean | 12.7238 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | -0.64855338 |
| Sum | 5725710 |
| Variance | 13.10167156 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 14 | 70587 | |
| 16 | 66326 | |
| 15 | 66184 | |
| 17 | 53648 | |
| 13 | 43407 | |
| 7 | 37651 | |
| 8 | 37553 | |
| 6 | 22886 | 5.1% |
| 9 | 22245 | 4.9% |
| 12 | 9262 | 2.1% |
| Other values (12) | 20251 | 4.5% |
| Value | Count | Frequency (%) |
| 0 | 2 | < 0.1% |
| 1 | 2 | < 0.1% |
| 2 | 61 | < 0.1% |
| 3 | 645 | 0.1% |
| 4 | 1211 | 0.3% |
| 5 | 1089 | 0.2% |
| 6 | 22886 | |
| 7 | 37651 | |
| 8 | 37553 | |
| 9 | 22245 |
| Value | Count | Frequency (%) |
| 21 | 2 | < 0.1% |
| 20 | 8 | < 0.1% |
| 19 | 25 | < 0.1% |
| 18 | 168 | < 0.1% |
| 17 | 53648 | |
| 16 | 66326 | |
| 15 | 66184 | |
| 14 | 70587 | |
| 13 | 43407 | |
| 12 | 9262 | 2.1% |
accept_time_hour
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATION| Distinct | 22 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 157 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 12.7613434 |
| Minimum | 0 |
|---|---|
| Maximum | 21 |
| Zeros | 2 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 6 |
| Q1 | 9 |
| median | 14 |
| Q3 | 16 |
| 95-th percentile | 17 |
| Maximum | 21 |
| Range | 21 |
| Interquartile range (IQR) | 7 |
Descriptive statistics
| Standard deviation | 3.621517342 |
|---|---|
| Coefficient of variation (CV) | 0.2837880956 |
| Kurtosis | -0.9784375606 |
| Mean | 12.7613434 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | -0.6478898375 |
| Sum | 5740601 |
| Variance | 13.11538786 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 14 | 69627 | |
| 15 | 67104 | |
| 16 | 66439 | |
| 17 | 54529 | |
| 13 | 41459 | |
| 7 | 37584 | |
| 8 | 37458 | |
| 9 | 23217 | 5.2% |
| 6 | 21664 | 4.8% |
| 12 | 9222 | 2.0% |
| Other values (12) | 21540 | 4.8% |
| Value | Count | Frequency (%) |
| 0 | 2 | < 0.1% |
| 1 | 2 | < 0.1% |
| 2 | 57 | < 0.1% |
| 3 | 592 | 0.1% |
| 4 | 1211 | 0.3% |
| 5 | 1092 | 0.2% |
| 6 | 21664 | |
| 7 | 37584 | |
| 8 | 37458 | |
| 9 | 23217 |
| Value | Count | Frequency (%) |
| 21 | 2 | < 0.1% |
| 20 | 8 | < 0.1% |
| 19 | 31 | < 0.1% |
| 18 | 1422 | 0.3% |
| 17 | 54529 | |
| 16 | 66439 | |
| 15 | 67104 | |
| 14 | 69627 | |
| 13 | 41459 | |
| 12 | 9222 | 2.0% |
first_order
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.4 MiB |
| 1 | |
|---|---|
| 0 | 58 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 449942 | |
| 0 | 58 | < 0.1% |
Length
Pie chart
| Value | Count | Frequency (%) |
| 1 | 449942 | |
| 0 | 58 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
cancel_before_accept
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.4 MiB |
| 0 | |
|---|---|
| 1 | 157 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 449843 | |
| 1 | 157 | < 0.1% |
Length
Pie chart
| Value | Count | Frequency (%) |
| 0 | 449843 | |
| 1 | 157 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 1335 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 16948 |
| Missing (%) | 3.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.9901580054 |
| Minimum | 0 |
|---|---|
| Maximum | 1 |
| Zeros | 393 |
| Zeros (%) | 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.9655172414 |
| Q1 | 0.9887640449 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 1 |
| Maximum | 1 |
| Range | 1 |
| Interquartile range (IQR) | 0.01123595506 |
Descriptive statistics
| Standard deviation | 0.03795187824 |
|---|---|
| Coefficient of variation (CV) | 0.03832911316 |
| Kurtosis | 450.6018829 |
| Mean | 0.9901580054 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -18.87983676 |
| Sum | 428789.9046 |
| Variance | 0.001440345062 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 232686 | |
| 0.98 | 1184 | 0.3% |
| 0.9777777778 | 1145 | 0.3% |
| 0.9818181818 | 1139 | 0.3% |
| 0.9821428571 | 1138 | 0.3% |
| 0.9866666667 | 1136 | 0.3% |
| 0.9887640449 | 1094 | 0.2% |
| 0.9787234043 | 1094 | 0.2% |
| 0.9875 | 1087 | 0.2% |
| 0.984375 | 1083 | 0.2% |
| Other values (1325) | 190266 | |
| (Missing) | 16948 | 3.8% |
| Value | Count | Frequency (%) |
| 0 | 393 | |
| 0.1666666667 | 2 | < 0.1% |
| 0.25 | 6 | < 0.1% |
| 0.3333333333 | 41 | < 0.1% |
| 0.4 | 10 | < 0.1% |
| 0.4285714286 | 1 | < 0.1% |
| 0.5 | 224 | |
| 0.5714285714 | 1 | < 0.1% |
| 0.6 | 21 | < 0.1% |
| 0.625 | 8 | < 0.1% |
| Value | Count | Frequency (%) |
| 1 | 232686 | |
| 0.998015873 | 13 | < 0.1% |
| 0.998003992 | 7 | < 0.1% |
| 0.9979919679 | 42 | < 0.1% |
| 0.997983871 | 28 | < 0.1% |
| 0.9979716024 | 21 | < 0.1% |
| 0.9979674797 | 8 | < 0.1% |
| 0.9979381443 | 16 | < 0.1% |
| 0.9979166667 | 22 | < 0.1% |
| 0.9979079498 | 13 | < 0.1% |
| Distinct | 3243 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 157 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 134.0647004 |
| Minimum | 2 |
|---|---|
| Maximum | 15598 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.4 MiB |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 9 |
| Q1 | 33 |
| median | 64 |
| Q3 | 112 |
| 95-th percentile | 517 |
| Maximum | 15598 |
| Range | 15596 |
| Interquartile range (IQR) | 79 |
Descriptive statistics
| Standard deviation | 283.955722 |
|---|---|
| Coefficient of variation (CV) | 2.118049876 |
| Kurtosis | 113.6159176 |
| Mean | 134.0647004 |
| Median Absolute Deviation (MAD) | 37 |
| Skewness | 8.052822639 |
| Sum | 60308067 |
| Variance | 80630.85206 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 8 | 5801 | 1.3% |
| 9 | 5616 | 1.2% |
| 10 | 5581 | 1.2% |
| 7 | 5356 | 1.2% |
| 11 | 5136 | 1.1% |
| 12 | 4881 | 1.1% |
| 13 | 4636 | 1.0% |
| 14 | 4551 | 1.0% |
| 15 | 4423 | 1.0% |
| 6 | 4340 | 1.0% |
| Other values (3233) | 399522 |
| Value | Count | Frequency (%) |
| 2 | 1 | < 0.1% |
| 3 | 68 | < 0.1% |
| 4 | 759 | 0.2% |
| 5 | 2329 | |
| 6 | 4340 | |
| 7 | 5356 | |
| 8 | 5801 | |
| 9 | 5616 | |
| 10 | 5581 | |
| 11 | 5136 |
| Value | Count | Frequency (%) |
| 15598 | 1 | |
| 7905 | 1 | |
| 7726 | 1 | |
| 7708 | 1 | |
| 7704 | 1 | |
| 7452 | 1 | |
| 7442 | 1 | |
| 7303 | 1 | |
| 7178 | 1 | |
| 7039 | 1 |
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.885242222 |
| Minimum | 0 |
|---|---|
| Maximum | 6 |
| Zeros | 37833 |
| Zeros (%) | 8.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 3 |
| Q3 | 4 |
| 95-th percentile | 6 |
| Maximum | 6 |
| Range | 6 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 1.742035737 |
|---|---|
| Coefficient of variation (CV) | 0.6037745196 |
| Kurtosis | -0.9533035557 |
| Mean | 2.885242222 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 0.116151224 |
| Sum | 1298359 |
| Variance | 3.034688507 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 4 | 83548 | |
| 3 | 80468 | |
| 2 | 80462 | |
| 1 | 78965 | |
| 5 | 49470 | |
| 6 | 39254 | |
| 0 | 37833 |
| Value | Count | Frequency (%) |
| 0 | 37833 | |
| 1 | 78965 | |
| 2 | 80462 | |
| 3 | 80468 | |
| 4 | 83548 | |
| 5 | 49470 | |
| 6 | 39254 |
| Value | Count | Frequency (%) |
| 6 | 39254 | |
| 5 | 49470 | |
| 4 | 83548 | |
| 3 | 80468 | |
| 2 | 80462 | |
| 1 | 78965 | |
| 0 | 37833 |
| Distinct | 45 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 159543 |
| Missing (%) | 35.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.472162833 |
| Minimum | 1 |
|---|---|
| Maximum | 67 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.4 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 2 |
| 95-th percentile | 3 |
| Maximum | 67 |
| Range | 66 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 1.132203578 |
|---|---|
| Coefficient of variation (CV) | 0.769074964 |
| Kurtosis | 191.2203067 |
| Mean | 1.472162833 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 8.377347618 |
| Sum | 427600 |
| Variance | 1.281884942 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 207777 | |
| 2 | 56033 | 12.5% |
| 3 | 15361 | 3.4% |
| 4 | 5644 | 1.3% |
| 5 | 2377 | 0.5% |
| 6 | 1232 | 0.3% |
| 7 | 669 | 0.1% |
| 8 | 435 | 0.1% |
| 9 | 270 | 0.1% |
| 10 | 177 | < 0.1% |
| Other values (35) | 482 | 0.1% |
| (Missing) | 159543 |
| Value | Count | Frequency (%) |
| 1 | 207777 | |
| 2 | 56033 | 12.5% |
| 3 | 15361 | 3.4% |
| 4 | 5644 | 1.3% |
| 5 | 2377 | 0.5% |
| 6 | 1232 | 0.3% |
| 7 | 669 | 0.1% |
| 8 | 435 | 0.1% |
| 9 | 270 | 0.1% |
| 10 | 177 | < 0.1% |
| Value | Count | Frequency (%) |
| 67 | 1 | |
| 57 | 1 | |
| 53 | 1 | |
| 48 | 1 | |
| 46 | 1 | |
| 45 | 1 | |
| 41 | 1 | |
| 39 | 1 | |
| 38 | 1 | |
| 37 | 1 |
cancelled_hour
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONMISSING| Distinct | 20 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 444782 |
| Missing (%) | 98.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 13.86738214 |
| Minimum | 2 |
|---|---|
| Maximum | 21 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.4 MiB |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 7 |
| Q1 | 11 |
| median | 15 |
| Q3 | 17 |
| 95-th percentile | 18 |
| Maximum | 21 |
| Range | 19 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 3.558332018 |
|---|---|
| Coefficient of variation (CV) | 0.2565972425 |
| Kurtosis | -0.6674073165 |
| Mean | 13.86738214 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | -0.7504902827 |
| Sum | 72360 |
| Variance | 12.66172675 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 15 | 871 | 0.2% |
| 17 | 799 | 0.2% |
| 16 | 789 | 0.2% |
| 18 | 515 | 0.1% |
| 14 | 491 | 0.1% |
| 9 | 361 | 0.1% |
| 8 | 337 | 0.1% |
| 7 | 244 | 0.1% |
| 10 | 231 | 0.1% |
| 13 | 189 | < 0.1% |
| Other values (10) | 391 | 0.1% |
| (Missing) | 444782 |
| Value | Count | Frequency (%) |
| 2 | 1 | < 0.1% |
| 3 | 1 | < 0.1% |
| 4 | 9 | < 0.1% |
| 5 | 16 | < 0.1% |
| 6 | 58 | < 0.1% |
| 7 | 244 | |
| 8 | 337 | |
| 9 | 361 | |
| 10 | 231 | |
| 11 | 132 | < 0.1% |
| Value | Count | Frequency (%) |
| 21 | 1 | < 0.1% |
| 20 | 9 | < 0.1% |
| 19 | 62 | < 0.1% |
| 18 | 515 | |
| 17 | 799 | |
| 16 | 789 | |
| 15 | 871 | |
| 14 | 491 | |
| 13 | 189 | < 0.1% |
| 12 | 102 | < 0.1% |
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.First rows
| order_time | order_id | order_date | allot_time | accept_time | pickup_time | delivered_time | rider_id | first_mile_distance | last_mile_distance | alloted_orders | delivered_orders | cancelled | undelivered_orders | lifetime_order_count | reassignment_method | reassignment_reason | reassigned_order | session_time | cancelled_time | total_dist | weekday | order_time_hour | accept_time_hour | first_order | cancel_before_accept | delivered_fraction | accept_order_diff | weekday_num | call_total | cancelled_hour | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 2021-01-26 02:21:35 | 556753 | 2021-01-26 | 2021-01-26 02:21:59 | 2021-01-26 02:22:08 | 2021-01-26 02:32:51 | 2021-01-26 02:49:47 | 11696 | 1.566600 | 2.65 | 46.0 | 46.0 | 0 | 0.0 | 621.0 | NaN | NaN | 0.0 | 175.550000 | NaT | 4.216600 | Tuesday | 2 | 2.0 | 1 | 0 | 1.000000 | 33.0 | 1 | 2.0 | NaN |
| 1 | 2021-01-26 02:33:16 | 556754 | 2021-01-26 | 2021-01-26 02:33:57 | 2021-01-26 02:34:45 | 2021-01-26 02:50:25 | 2021-01-26 03:11:15 | 18117 | 2.520700 | 2.76 | 8.0 | 8.0 | 0 | 0.0 | 105.0 | NaN | NaN | 0.0 | 3.266667 | NaT | 5.280700 | Tuesday | 2 | 2.0 | 1 | 0 | 1.000000 | 89.0 | 1 | 1.0 | NaN |
| 2 | 2021-01-26 02:39:49 | 556755 | 2021-01-26 | 2021-01-26 02:39:57 | 2021-01-26 02:40:13 | 2021-01-26 02:56:00 | 2021-01-26 03:12:46 | 18623 | 2.207400 | 4.80 | 1.0 | 1.0 | 0 | 0.0 | 66.0 | NaN | NaN | 0.0 | 9.816667 | NaT | 7.007400 | Tuesday | 2 | 2.0 | 1 | 0 | 1.000000 | 24.0 | 1 | NaN | NaN |
| 3 | 2021-01-26 02:47:53 | 556756 | 2021-01-26 | 2021-01-26 02:48:25 | 2021-01-26 02:49:06 | 2021-01-26 03:21:51 | 2021-01-26 03:41:05 | 15945 | 2.189400 | 6.38 | 1.0 | 1.0 | 0 | 0.0 | 127.0 | NaN | NaN | 0.0 | 17.533333 | NaT | 8.569400 | Tuesday | 2 | 2.0 | 1 | 0 | 1.000000 | 73.0 | 1 | 3.0 | NaN |
| 4 | 2021-01-26 03:06:30 | 556757 | 2021-01-26 | 2021-01-26 03:07:21 | 2021-01-26 03:07:57 | 2021-01-26 03:31:38 | 2021-01-26 04:00:15 | 17589 | 2.787000 | 4.01 | 34.0 | 34.0 | 0 | 0.0 | 84.0 | NaN | NaN | 0.0 | 1.350000 | NaT | 6.797000 | Tuesday | 3 | 3.0 | 1 | 0 | 1.000000 | 87.0 | 1 | 1.0 | NaN |
| 5 | 2021-01-26 03:07:16 | 556758 | 2021-01-26 | 2021-01-26 03:12:14 | 2021-01-26 03:12:27 | 2021-01-26 03:25:36 | 2021-01-26 03:45:51 | 1469 | 2.481800 | 5.18 | 296.0 | 294.0 | 0 | 2.0 | 1506.0 | NaN | NaN | 0.0 | 175.550000 | NaT | 7.661800 | Tuesday | 3 | 3.0 | 1 | 0 | 0.993243 | 311.0 | 1 | 1.0 | NaN |
| 6 | 2021-01-26 03:10:50 | 556759 | 2021-01-26 | 2021-01-26 03:11:18 | 2021-01-26 03:12:05 | 2021-01-26 03:19:31 | 2021-01-26 03:26:04 | 8851 | 2.809100 | 3.40 | 45.0 | 45.0 | 0 | 0.0 | 1460.0 | NaN | NaN | 0.0 | 175.550000 | NaT | 6.209100 | Tuesday | 3 | 3.0 | 1 | 0 | 1.000000 | 75.0 | 1 | 2.0 | NaN |
| 7 | 2021-01-26 03:14:10 | 556760 | 2021-01-26 | 2021-01-26 03:14:38 | 2021-01-26 03:14:44 | 2021-01-26 03:33:53 | 2021-01-26 03:42:38 | 8493 | 0.025681 | 0.16 | 54.0 | 53.0 | 0 | 1.0 | 270.0 | NaN | NaN | 0.0 | 44.166667 | NaT | 0.185681 | Tuesday | 3 | 3.0 | 1 | 0 | 0.981481 | 34.0 | 1 | NaN | NaN |
| 8 | 2021-01-26 03:14:20 | 556761 | 2021-01-26 | 2021-01-26 03:14:50 | 2021-01-26 03:15:14 | 2021-01-26 04:00:02 | 2021-01-26 04:13:31 | 11543 | 2.444200 | 2.86 | 29.0 | 29.0 | 0 | 0.0 | 955.0 | NaN | NaN | 0.0 | 2.500000 | NaT | 5.304200 | Tuesday | 3 | 3.0 | 1 | 0 | 1.000000 | 54.0 | 1 | NaN | NaN |
| 9 | 2021-01-26 03:15:18 | 556762 | 2021-01-26 | 2021-01-26 03:21:27 | 2021-01-26 03:22:04 | 2021-01-26 04:14:56 | 2021-01-26 04:38:39 | 21037 | 2.878600 | 2.61 | 0.0 | 0.0 | 0 | 0.0 | 1.0 | auto | Reassignment Request from SE portal. | 1.0 | 175.550000 | NaT | 5.488600 | Tuesday | 3 | 3.0 | 1 | 0 | NaN | 406.0 | 1 | NaN | NaN |
Last rows
| order_time | order_id | order_date | allot_time | accept_time | pickup_time | delivered_time | rider_id | first_mile_distance | last_mile_distance | alloted_orders | delivered_orders | cancelled | undelivered_orders | lifetime_order_count | reassignment_method | reassignment_reason | reassigned_order | session_time | cancelled_time | total_dist | weekday | order_time_hour | accept_time_hour | first_order | cancel_before_accept | delivered_fraction | accept_order_diff | weekday_num | call_total | cancelled_hour | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 449990 | 2021-02-06 10:03:00 | 130221 | 2021-02-06 | 2021-02-06 10:03:01 | 2021-02-06 10:04:03 | 2021-02-06 10:07:44 | 2021-02-06 10:15:03 | 3617 | 2.1965 | 1.24 | 22.0 | 22.0 | 0 | 0.0 | 34.0 | NaN | NaN | 0.0 | 376.416667 | NaT | 3.4365 | Saturday | 10 | 10.0 | 1 | 0 | 1.000000 | 63.0 | 5 | NaN | NaN |
| 449991 | 2021-02-06 10:03:01 | 130222 | 2021-02-06 | 2021-02-06 10:04:30 | 2021-02-06 10:06:04 | 2021-02-06 10:26:23 | 2021-02-06 10:36:09 | 773 | 1.4707 | 1.12 | 147.0 | 146.0 | 0 | 1.0 | 773.0 | NaN | NaN | 0.0 | 268.166667 | NaT | 2.5907 | Saturday | 10 | 10.0 | 1 | 0 | 0.993197 | 183.0 | 5 | 1.0 | NaN |
| 449992 | 2021-02-06 10:03:06 | 130223 | 2021-02-06 | 2021-02-06 10:03:47 | 2021-02-06 10:04:07 | 2021-02-06 10:15:01 | 2021-02-06 10:26:06 | 1407 | 0.3007 | 1.26 | 265.0 | 264.0 | 0 | 1.0 | 477.0 | NaN | NaN | 0.0 | 209.266667 | NaT | 1.5607 | Saturday | 10 | 10.0 | 1 | 0 | 0.996226 | 61.0 | 5 | 1.0 | NaN |
| 449993 | 2021-02-06 10:03:11 | 130224 | 2021-02-06 | 2021-02-06 10:03:12 | 2021-02-06 10:03:35 | 2021-02-06 10:15:43 | 2021-02-06 10:25:14 | 745 | 2.7013 | 3.72 | 200.0 | 200.0 | 0 | 0.0 | 290.0 | NaN | NaN | 0.0 | 229.250000 | NaT | 6.4213 | Saturday | 10 | 10.0 | 1 | 0 | 1.000000 | 24.0 | 5 | 1.0 | NaN |
| 449994 | 2021-02-06 10:03:14 | 130225 | 2021-02-06 | 2021-02-06 10:03:23 | 2021-02-06 10:03:43 | 2021-02-06 10:15:36 | 2021-02-06 10:34:10 | 7823 | 1.7916 | 2.60 | 202.0 | 201.0 | 0 | 1.0 | 1426.0 | NaN | NaN | 0.0 | 273.233333 | NaT | 4.3916 | Saturday | 10 | 10.0 | 1 | 0 | 0.995050 | 29.0 | 5 | NaN | NaN |
| 449995 | 2021-02-06 10:03:16 | 130226 | 2021-02-06 | 2021-02-06 10:03:44 | 2021-02-06 10:04:14 | 2021-02-06 10:27:29 | 2021-02-06 10:44:08 | 1006 | 0.5789 | 0.19 | 4.0 | 4.0 | 0 | 0.0 | 127.0 | NaN | NaN | 0.0 | 369.516667 | NaT | 0.7689 | Saturday | 10 | 10.0 | 1 | 0 | 1.000000 | 58.0 | 5 | 1.0 | NaN |
| 449996 | 2021-02-06 10:03:17 | 130227 | 2021-02-06 | 2021-02-06 10:03:18 | 2021-02-06 10:04:34 | 2021-02-06 10:22:17 | 2021-02-06 10:31:43 | 279 | 1.9863 | 1.19 | 81.0 | 81.0 | 0 | 0.0 | 105.0 | NaN | NaN | 0.0 | 239.133333 | NaT | 3.1763 | Saturday | 10 | 10.0 | 1 | 0 | 1.000000 | 77.0 | 5 | 1.0 | NaN |
| 449997 | 2021-02-06 10:03:18 | 130228 | 2021-02-06 | 2021-02-06 10:04:06 | 2021-02-06 10:04:39 | 2021-02-06 10:19:06 | 2021-02-06 10:26:56 | 3161 | 1.5944 | 1.61 | 28.0 | 28.0 | 0 | 0.0 | 1488.0 | NaN | NaN | 0.0 | 204.150000 | NaT | 3.2044 | Saturday | 10 | 10.0 | 1 | 0 | 1.000000 | 81.0 | 5 | 2.0 | NaN |
| 449998 | 2021-02-06 10:03:19 | 130229 | 2021-02-06 | 2021-02-06 10:03:19 | 2021-02-06 10:05:41 | 2021-02-06 10:20:39 | 2021-02-06 10:30:41 | 9396 | 2.8939 | 4.68 | 72.0 | 72.0 | 0 | 0.0 | 105.0 | NaN | NaN | 0.0 | 65.583333 | NaT | 7.5739 | Saturday | 10 | 10.0 | 1 | 0 | 1.000000 | 142.0 | 5 | 4.0 | NaN |
| 449999 | 2021-02-06 10:03:24 | 130230 | 2021-02-06 | 2021-02-06 10:03:45 | 2021-02-06 10:05:14 | 2021-02-06 10:13:26 | 2021-02-06 10:19:41 | 2078 | 1.8925 | 0.09 | 30.0 | 30.0 | 0 | 0.0 | 108.0 | NaN | NaN | 0.0 | 212.000000 | NaT | 1.9825 | Saturday | 10 | 10.0 | 1 | 0 | 1.000000 | 110.0 | 5 | 1.0 | NaN |